The data that is analyzed in this report is related to road accidents occurring in Geneva. These type of data are usually presented in a table, but there are better ways, such as using maps.

Let’s first look at the overall data with a first overview of the number of accidents by day and year.

Extract of the information on road accidents in Geneva
date groupe_accident commune conditions_meteo
2010-06-16 Dérapage ou perte de maîtrise Bernex Pluie
2010-02-25 Accident impliquant des piétons Genève Beau temps
2010-09-13 Accident en parquant Genève Beau temps
2010-12-06 Accident en s’engageant sur une route Carouge Beau temps
2010-11-04 Accident en quittant une route Pregny-Chambésy Temps couvert
2010-12-26 Dérapage ou perte de maîtrise Genthod Temps couvert
2010-04-09 Accident par tamponnement Bernex Beau temps
2010-08-06 Dérapage ou perte de maîtrise Lancy Beau temps
2010-11-30 Dérapage ou perte de maîtrise Genève Chute de neige
2010-02-01 Dérapage ou perte de maîtrise Genève Beau temps
2010-07-14 Accident par tamponnement Versoix Beau temps
2010-05-19 Dérapage ou perte de maîtrise Genève Beau temps
2010-03-04 Accident par tamponnement Genève Beau temps
2010-03-01 Dérapage ou perte de maîtrise Genève Beau temps
2010-06-20 Accident par tamponnement Genève Beau temps

Since the information on longitude and latitude is available, it is possible to plot on a graph the exact location of each accident.

An extra layer with Geneva map is added on top of the location.

These set of maps show the location of road accidents in Geneva during the year 2018. But are there more accidents during a rainy day ? Surprisingly the data indicates that accidents are occurring during sunny days.

But let’s look at the number of accidents per year by developing a set of maps that will display accidents by year since 2015.